/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

1 vote118 views1 answer
Sql convert month name to number
SQL
0 vote129 views2 answers
How to get json data mysql
SQL
0 vote146 views1 answer
Get schema of table sql
SQL
0 vote139 views1 answer
Sqlite referential integrity
SQL
6 votes134 views1 answer
Phpmyadmin password root
SQL
10 votes136 views4 answers
Drop primary key
SQL
1 vote134 views1 answer
Postgres check for foreign key
SQL
0 vote129 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote232 views4 answers
Stored procedure sql
SQL
0 vote145 views1 answer
Sql common columns
SQL

Share