Answers for "mysql keyword search"

sql searching via key word

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

Posted by: Guest on April-17-2020

sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

Posted by: Guest on April-17-2020

mysql keyword search

SELECT title, description
FROM film
WHERE
(
    title LIKE '%Drama%'
    OR description LIKE '%Drama%'
);

Posted by: Guest on September-04-2021

Code answers related to "mysql keyword search"