/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

8 votes199 views4 answers
Mysql update one table from another table multiple columns
SQL
13 votes208 views2 answers
Get date from now() mysql
SQL
1 vote222 views2 answers
Mysql limit offset
SQL
0 vote209 views1 answer
Oracle list user locked
SQL
1 vote193 views1 answer
Sample in sql
SQL
0 vote219 views2 answers
How to prevent sql injection in java
SQL
0 vote212 views1 answer
Mysql where in maintain order
SQL
0 vote201 views1 answer
How to check which sp is running in sql server
SQL
0 vote227 views1 answer
Oracle dynamic select into
SQL
0 vote219 views1 answer
Time data type in mysql
SQL

Share