Search
 
SCRIPT & CODE EXAMPLE
 

SQL

What is the difference between the LIKE and REGEXP operators in mysql?

LIKE and REGEXP operators are used to express with ^ and %.

SELECT * FROM employee WHERE emp_name REGEXP "^b";
SELECT * FROM employee WHERE emp_name LIKE "%b";
Comment

PREVIOUS NEXT
Code Example
Sql :: select-groups-of-row-only-having-specific-value 
Sql :: closure in sql 
Sql :: ring get column value from the fetched row using the odbc_getdata() 
Sql :: Insert and initialize a SQL column with value dependent on another column data 
Sql :: <sql:datasource var="Snapsho" 
Sql :: mamp find mysql port number mac 
Sql :: mysql grant user privileges to database that has suffix and prefix 
Sql :: sqlite send a query to a Sqlite DB with Ruby 
Sql :: sql column as header 
Sql :: power query case when 
Sql :: loop through a table variable in TSQL without using a cursor 
Sql :: sql select column name like from multiple tables 
Sql :: mysql max number not returning correct value 
Sql :: MQL4 mql4 run ea on all symbols by adding to just one chart 
Sql :: match end of string regex sql 
Sql :: fast sql column count 
Sql :: error access to system table innodb is rejected 
Sql :: how to find lowest salary by departments ? 
Sql :: oracle run_duration average 
Sql :: sql server in linux 
Sql :: subquery in Update 
Sql :: import data from excel to sql server automatically 
Sql :: change order of sql columns 
Sql :: id sql 
Sql :: multiple tricky query in sql server 
Csharp :: how to load the active scene unity 
Csharp :: change border color of textfield in flutter 
Csharp :: check dotnet version command line 
Csharp :: how to stop window from terminating c# visual studio 
Csharp :: unity how to set an objects postion x,y,z 
ADD CONTENT
Topic
Content
Source link
Name
9+6 =