/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 vote226 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote212 views1 answer
Mysql return column names when table is empty
SQL
0 vote217 views1 answer
Get number of tables in database sql
SQL
0 vote233 views1 answer
Mariadb create index if not exists
SQL
7 votes215 views1 answer
Safe update mysql
SQL
0 vote248 views2 answers
Start mysql server using docker
SQL
0 vote216 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote240 views3 answers
Read all columns of a table sql
SQL
1 vote200 views1 answer
Find logged in users mysql
SQL
1 vote247 views1 answer
Mysql find most common value
SQL

Share