What is the correct SQL query statement for "SELECT LIKE" using tableadapter query configuration wizard for visual studio 2013?

Question

I want to know what is the correct SQL query statement for "SELECT LIKE" in the TableAdapter query configuration wizard with a parameter in visual studio and want to add a query for search purposes because it's really hard to find the answer I need on the internet so please can someone help me

THIS IS WHAT I WROTE:

SELECT * FROM table1 WHERE name LIKE '%'+@name+'%'

but it doesn't work

score 0 · Answer 1 · answered May 07 '23 at 14:50

0

As per this answer, you can't use + to concatenate strings in MySQL; instead, use the CONCAT function:

SELECT * FROM table1 WHERE name LIKE CONCAT('%', @name, '%')

answered May 07 '23 at 14:50

Bradley Grainger

27,458
4
91
108

is it also working in visual studio? – blewwwuuu May 07 '23 at 15:05
and the configuration says "Error in WHERE clause near ','. Unable to parse query text. – blewwwuuu May 07 '23 at 15:09
1

Sorry, I don't use Visual Studio 2013 or the TableAdapter query configuration wizard. Sounds like a bug in that feature if it can't parse completely valid SQL. – Bradley Grainger May 07 '23 at 17:17

What is the correct SQL query statement for "SELECT LIKE" using tableadapter query configuration wizard for visual studio 2013?

1 Answers1