Hi,
i want to write a query for employee's who's name start with "a" and end with "b".
Thnks in advance :)
Hi,
i want to write a query for employee's who's name start with "a" and end with "b".
Thnks in advance :)
See WHERE column LIKE
See
WHERE column LIKE
i want to write the query for e.g there a name RICKY now i want a query where name start
with R and end with Y , so that we will get output like RICKY
SELECT * FROM table_name WHERE column_name LIKE 'R%' AND colum_name LIKE '%Y'
or:
SELECT * FROM table_name WHERE column_name LIKE 'R%Y'
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.