/SQL/Mysql keyword search

Mysql keyword search

Sql searching via key word

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

0

Source: stackoverflow.com

Sql searching via key word

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

0

Source: stackoverflow.com

Mysql keyword search

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

0

Source: stackoverflow.com

Similar codes

0 vote246 views1 answer
Rabbitmq service not starting
SQL
0 vote246 views1 answer
Mysql:5.6 syntax create table
SQL
2 votes251 views1 answer
Mysql how to store lat,lng
SQL
1 vote280 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote266 views1 answer
Mysql extract day from date leading zero
SQL
0 vote249 views1 answer
Mysql cdn link
SQL
1 vote272 views2 answers
Get table column names sql laravel
SQL
5 votes246 views2 answers
Copy data from one database to another
SQL
0 vote270 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote251 views2 answers
Install phoenix
SQL

Share