Well if you know the order of your words.. you can use:
SELECT `name` FROM `table` WHERE `name` REGEXP 'Stylus.+2100'
Also you can use:
SELECT `name` FROM `table` WHERE `name` LIKE '%Stylus%' AND `name` LIKE '%2100%'
More Related Contents:
- #1139 – Got error ‘repetition-operator operand invalid’ from regexp
- MySQL – How to search for exact word match using LIKE?
- How to do a regular expression replace in MySQL?
- quick selection of a random row from a large table in mysql
- MySQL: is a SELECT statement case sensitive?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- MySQL Split Comma Separated String Into Temp Table
- How to remove all non-alpha numeric characters from a string in MySQL?
- Combine Multiple child rows into one row MYSQL
- MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
- Search for string within text column in MySQL
- How to get an age from a D.O.B field in MySQL?
- MySQL join query using like?
- Like Case Sensitive in MySQL
- MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
- MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
- How do I get the first day of the week of a date in mysql?
- MySQL error 1241: Operand should contain 1 column(s)
- quick selection of a random row from a large table in mysql
- Converting SELECT DISTINCT ON queries from Postgresql to MySQL
- mysql select sum group by date
- MySQL – SQL_BIG_SELECTS
- MySQL INNER JOIN select only one row from second table
- Mysql: Order by like?
- MySQL Select Query – Get only first 10 characters of a value
- What is the default MySQL JOIN behaviour, INNER or OUTER?
- how to use a like with a join in sql?
- How to use Table output from stored MYSQL Procedure
- How do you force mysql LIKE to be case sensitive? [duplicate]
- MySQL cartesian product between two SELECT statements