/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

3 votes276 views1 answer
Sql replace character in string in all records
SQL
0 vote296 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
2 votes296 views2 answers
Calculate percentage in sql
SQL
6 votes282 views1 answer
T-sql test if table exists
SQL
2 votes260 views1 answer
Oracle sql query to make column data uppercase
SQL
4 votes262 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote288 views1 answer
Foreign key type uniqu mysql
SQL
1 vote277 views1 answer
How to use a trigger to validate input data
SQL
0 vote285 views1 answer
Provide hardcoded value in the mysql query
SQL
3 votes296 views1 answer
Sql add two values together
SQL

Share