/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 vote108 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote102 views1 answer
Learn sqlite dart
SQL
0 vote138 views1 answer
Eliminate zero from integer mysql
SQL
0 vote106 views1 answer
Sql count * vs count 1
SQL
1 vote100 views2 answers
Mysql order by date asc null last
SQL
0 vote124 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote113 views1 answer
Sql server list locks
SQL
0 vote108 views1 answer
Order by in codeigniter query builder
SQL
0 vote104 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote103 views1 answer
Mysql 1 hour ago
SQL

Share