Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Best approach to search a mixed field

Best approach to search a mixed field

Thread began 3/04/2022 4:35 pm by Paul | Last modified 3/04/2022 5:52 pm by Ray Borduin | 111 views | 2 replies |

3/04/2022 4:35 pm | #1 PaulBeta Tester

Best approach to search a mixed field

I have a dataset of over a million rows.

One of the field contains data similar to these 2 formats;

123-456-789-01234

and

123-45678-90123

I need to build search page which return matches where the query may include the following scenarios:

45678

or

789

or

123

or

123-456-789 or 123-45678

Will the 'include' option in the search wizard satisfy these search examples?

3/04/2022 4:48 pm | #2 Ray BorduinWebAssist

If I understand you correctly... then yes

Did this help? Tips are appreciated...

3/04/2022 4:53 pm | #3 PaulBeta Tester

cool. i'll give it a go.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.