/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 vote283 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote214 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
22 votes173 views6 answers
Create sql table
SQL
1 vote248 views1 answer
How to select the nth row in a SQL database table?
SQL
18 votes162 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote173 views1 answer
Mysql last year
SQL
0 vote198 views1 answer
C# sql transaction multiple connections
SQL
1 vote182 views1 answer
Mysql query bulk insert
SQL
0 vote174 views1 answer
Mysql coonect sample code
SQL
1 vote156 views1 answer
Error code 1175 mysql fix
SQL

Share