U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Simple SQL question

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Simple SQL question [message #31373 is a reply to message #31366]

Fri, 25 February 2011 20:00

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

koldo wrote on Fri, 25 February 2011 06:43

Hello all

I wanted to select all registers from columns Name, Surname and Location that contains either text1 or text2.

For example, if the table is:

Name	Surname 	Location
John	Doe		M�nchen
Mary 	Poppins		Bruxelles

with text1 = "pin" and text2 = "elle", the second register would be selected.

How could it be done?

http://www.postgresql.org/docs/8.3/static/functions-matching .html

I guess it is even SQL standard.

In SqlExp, use Like.

Mirek

Report message to a moderator

[Message index]

		Simple SQL question By: koldo on Fri, 25 February 2011 12:43
		Re: Simple SQL question By: mirek on Fri, 25 February 2011 20:00
		Re: Simple SQL question By: koldo on Sun, 27 February 2011 09:19
		Re: Simple SQL question By: mirek on Fri, 04 March 2011 12:00
		Re: Simple SQL question By: koldo on Fri, 04 March 2011 13:36
		Re: Simple SQL question By: mirek on Sat, 05 March 2011 09:10
		Re: Simple SQL question By: koldo on Sat, 05 March 2011 15:11
		Re: Simple SQL question By: mirek on Sun, 06 March 2011 19:00
		Re: Simple SQL question By: koldo on Sun, 06 March 2011 21:31

Previous Topic:	SQLArray + Like() + Accents problem
Next Topic:	Demo Package of FieldOperator usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Aug 02 22:21:17 CEST 2025

Total time taken to generate the page: 0.09067 seconds