smart190 Posted February 18, 2009 Share Posted February 18, 2009 HIis possible to find with simple sql query in table some word example:table column --> ID/text1/text2table rows: 0001/test1, test2, test3/test01 0002/test1, test4, test5/test021) I have to find the first word (test1)2) and find that in other rows is there possible matches (test1) Link to comment Share on other sites More sharing options...
justsomeguy Posted February 18, 2009 Share Posted February 18, 2009 No, that query would be pretty complex, not very simple. Can you use a server-side language like PHP to help process? Link to comment Share on other sites More sharing options...
smart190 Posted February 25, 2009 Author Share Posted February 25, 2009 No, that query would be pretty complex, not very simple. Can you use a server-side language like PHP to help process?we can't use php in that server Link to comment Share on other sites More sharing options...
justsomeguy Posted February 25, 2009 Share Posted February 25, 2009 I'm not even sure how to write a query to get rows containing the first word of a certain row. I would use PHP or ASP or JSP or something else to help the processing. It might be possible with SQL alone, you could definitely do it with something like a stored procedure, but it would take me a lot of testing to figure out the right way. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.