/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 vote264 views1 answer
Concat first name and last name in mysql
SQL
0 vote219 views1 answer
Nueva tabla mysql
SQL
0 vote234 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
7 votes237 views1 answer
Sql limit decimal places
SQL
0 vote259 views1 answer
Bigrock database connection string
SQL
0 vote258 views1 answer
Mysql faster delete
SQL
0 vote224 views2 answers
Auto increment column in mysql query results
SQL
0 vote201 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote278 views1 answer
Stop and start mysql
SQL
0 vote248 views1 answer
Sql server for loop
SQL

Share