1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

selecting a converted string?

Discussion in 'Databases' started by mahmood, Apr 9, 2006.

0
  1. #1
    Say I have a function that converts a string like "mike & toni" to "mike and toni" ie if it finds "&", it would replace it with "and", other wise returns the same string.

    Now I have no way to realize that it was "mike & toni" or "mike and toni" in the first place. - And I mention that the real conversion is far more complex and not reversable like this one -

    Having "mike and toni" I want to search the database for its ocourence. The best way is that I query the database for all data that would have been converted to "mike and toni".

    Lets say I call the function "convertIt", This is the seudocode

    select * from myTable where covertIt(`columnName`) equals "mike and toni"[/PHP\]

Well, I tried above and it returns error.

How would you do that?

One possibility is that I select everything convert them using my "convertIt" function and compare them to "mike and toni", but takes a lot of time
    PHP:
     
    mahmood, Apr 9, 2006 IP
  2. donteatchicken

    donteatchicken Well-Known Member

    Messages:
    432
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    118
    #2
    what error does it return?
     
    donteatchicken, Apr 21, 2006 IP
    Greg-J likes this.